<html>
	<head>
	<title>ShotDev.Com Tutorial</title>

  <style>
	#backg{
			margin-left: 50px;
		margin-right: 50px;
		background: #191919 url(images/img04.jpg) repeat;
	}
	#enter{
		color: yellow;
	}
	#whitecolor{
		color: white;
	}
  </style>
	</head>
	<body id="backg">
		<?php
			$objConnect = oci_connect("iss","password","orcl");
			$strSQL = "SELECT * FROM iss.NHAN_VIEN";
			$objParse = oci_parse ($objConnect, $strSQL);
			oci_execute ($objParse);
		?>
			<table id="enter" border="1">
			  <tr>
				<th> <div align="center">HO </div></th>
				<th> <div align="center">TEN </div></th>
				<th> <div align="center">MA_NV </div></th>
				<th> <div align="center">NGAY_SINH </div></th>
				<th> <div align="center">EMAIL </div></th>
				<th> <div align="center">MS_THUE</div></th>
				<th> <div align="center">LUONG</div></th>
				<th> <div align="center">MA_TP</div></th>
				<th> <div align="center">MA_PB</div></th>
				<th> <div align="center">EDIT</div></th>
			  </tr>
		<?php
		while($objResult = oci_fetch_array($objParse,OCI_BOTH))
		{
			?>
			  <tr id="whitecolor">
				<td><div align="left"><?php echo $objResult["HO"];?></div></td>
				<td><?php echo $objResult["TEN"];?></td>
				<td><?php echo $objResult["MA_NV"];?></td>
				<td><div align="center"><?php echo $objResult["NGAY_SINH"];?></div></td>
				<td align="left"><?php echo $objResult["EMAIL"];?></td>
				<td align="right"><?php echo $objResult["MS_THUE"];?></td>
				<td align="right"><?php echo $objResult["LUONG"];?></td>
				<td align="right"><?php echo $objResult["MA_TP"];?></td>
				<td align="right"><?php echo $objResult["MA_PB"];?></td>
				<td align="center"><a href="ass_update2.php?ID_NV=<?php echo $objResult["MA_NV"];?>">Edit</a></td>
			  </tr>
			<?php
		}
		?>
		</table>
		<?php
		oci_close($objConnect);
		?>
	</body>
</html>
